CREATE TABLE Faculty2(
facId NUMBER(4) PRIMARY KEY,
lastName VARCHAR2(15),
firstName VARCHAR2(10),
dept VARCHAR2(10),
rank VARCHAR2(10),
salary NUMBER(8,2));

INSERT INTO FACULTY2 VALUES(101,'Adams','John','Art','Professor',100000);
INSERT INTO FACULTY2 VALUES(105,'Tanaka','Neil','CSC','Instructor',50000);
INSERT INTO FACULTY2 VALUES(110,'Byrne','Simon','Math','Assistant',60000);
INSERT INTO FACULTY2 VALUES(115,'Smith','Susan','History','Associate',80000);
INSERT INTO FACULTY2 VALUES(221,'Smith','Janet','CSC','Professor',110000);


CREATE OR REPLACE TYPE FacultyType AS OBJECT (
facId NUMBER(4),
lName VARCHAR2(15),
fName VARCHAR2(10),
department VARCHAR2(10),
rnk VARCHAR2(10));

CREATE VIEW FacultyView OF FacultyType WITH OBJECT
IDENTIFIER (facId) AS SELECT f.facId, f.lastName,
f.firstName, f.dept, f.rank
FROM Faculty2 f;


--Note that we can now treat a facultyview instance as an object, using ref() and dot notation.

select ref(v) from facultyview v where v.fname='Janet';